﻿
SET IDENTITY_INSERT [cTest].[sys_Organization] ON 
INSERT [cTest].[sys_Organization] ([IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate], [Id], [ParentId], [Name], [TreeCode], [Leaf], [Level], [Status], [Index], [BusinessType],[OrganizationType], [OrganizationCode]) VALUES (0, N'admin', CAST(N'2018-05-15T01:50:54.3670000' AS DateTime2), N'admin', CAST(N'2019-01-29T06:43:09.7936567' AS DateTime2), 1, NULL, N'企业集团', N'1', 0, 1,  0, 1, 0, 0, N'ORG2019010100001')
INSERT [cTest].[sys_Organization] ([IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate], [Id], [ParentId], [Name], [TreeCode], [Leaf], [Level], [Status], [Index], [BusinessType],[OrganizationType], [OrganizationCode]) VALUES (0, N'admin', CAST(N'2018-05-15T01:50:54.3670000' AS DateTime2), N'admin', CAST(N'2019-01-29T06:43:09.7936614' AS DateTime2), 2, 1, N'人力资源部', N'1-2', 1, 2,  0, 1, 2, 0, N'ORG2019010100002')
INSERT [cTest].[sys_Organization] ([IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate], [Id], [ParentId], [Name], [TreeCode], [Leaf], [Level], [Status], [Index], [BusinessType],[OrganizationType], [OrganizationCode]) VALUES (0, N'admin', CAST(N'2018-05-15T01:50:54.3670000' AS DateTime2), N'admin', CAST(N'2019-01-29T06:48:07.4577097' AS DateTime2), 3, 1, N'采购部', N'1-3', 1, 2,  0, 2, 4, 0, N'ORG2019010100003')
INSERT [cTest].[sys_Organization] ([IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate], [Id], [ParentId], [Name], [TreeCode], [Leaf], [Level], [Status], [Index], [BusinessType],[OrganizationType], [OrganizationCode]) VALUES (0, N'admin', CAST(N'2018-05-15T01:50:54.3670000' AS DateTime2), N'admin', CAST(N'2019-01-29T06:48:07.4577129' AS DateTime2), 4, 1, N'销售部', N'1-4', 1, 2,  0, 3, 8, 0, N'ORG2019010100004')
INSERT [cTest].[sys_Organization] ([IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate], [Id], [ParentId], [Name], [TreeCode], [Leaf], [Level], [Status], [Index], [BusinessType],[OrganizationType], [OrganizationCode]) VALUES (0, N'admin', CAST(N'2018-05-15T01:50:54.3670000' AS DateTime2), N'admin', CAST(N'2019-01-29T06:48:07.4577129' AS DateTime2), 5, 1, N'仓储部', N'1-5', 1, 2,  0, 4, 16, 0, N'ORG2019010100005')
INSERT [cTest].[sys_Organization] ([IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate], [Id], [ParentId], [Name], [TreeCode], [Leaf], [Level], [Status], [Index], [BusinessType],[OrganizationType], [OrganizationCode]) VALUES (0, N'admin', CAST(N'2018-05-15T01:50:54.3670000' AS DateTime2), N'admin', CAST(N'2019-01-29T06:48:07.4577134' AS DateTime2), 6, 1, N'生产部', N'1-6', 1, 2,  0, 5, 32, 0, N'ORG2019010100006')
INSERT [cTest].[sys_Organization] ([IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate], [Id], [ParentId], [Name], [TreeCode], [Leaf], [Level], [Status], [Index], [BusinessType],[OrganizationType], [OrganizationCode]) VALUES (0, N'admin', CAST(N'2018-05-15T01:50:54.3670000' AS DateTime2), N'admin', CAST(N'2019-01-29T06:48:07.4577134' AS DateTime2), 7, 1, N'质检部', N'1-7', 1, 2,  0, 6, 64, 0, N'ORG2019010100007')
INSERT [cTest].[sys_Organization] ([IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate], [Id], [ParentId], [Name], [TreeCode], [Leaf], [Level], [Status], [Index], [BusinessType],[OrganizationType], [OrganizationCode]) VALUES (0, N'admin', CAST(N'2018-05-15T01:50:54.3670000' AS DateTime2), N'admin', CAST(N'2019-01-29T06:48:07.4577139' AS DateTime2), 8, 1, N'财务部', N'1-8', 1, 2,  0, 7, 256, 0, N'ORG2019010100008')
INSERT [cTest].[sys_Organization] ([IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate], [Id], [ParentId], [Name], [TreeCode], [Leaf], [Level], [Status], [Index], [BusinessType],[OrganizationType], [OrganizationCode]) VALUES (0, N'admin', CAST(N'2018-05-15T01:50:54.3670000' AS DateTime2), N'admin', CAST(N'2018-05-15T01:50:54.3670000' AS DateTime2), 9, 1, N'市场部', N'1-9', 1, 2,  0, 8, 128, 0, N'ORG2019010100009')
INSERT [cTest].[sys_Organization] ([IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate], [Id], [ParentId], [Name], [TreeCode], [Leaf], [Level], [Status], [Index], [BusinessType],[OrganizationType], [OrganizationCode]) VALUES (0, N'admin', CAST(N'2018-05-15T01:50:54.3670000' AS DateTime2), N'admin', CAST(N'2018-05-15T01:50:54.3670000' AS DateTime2), 10, 1, N'运营部', N'1-10', 1, 2,  0, 9, 1, 0, N'ORG2019010100010')
SET IDENTITY_INSERT [cTest].[sys_Organization] OFF

INSERT [cTest].[sys_Role] ([Id], [Name], [NormalizedName], [ConcurrencyStamp], [DisplayName], [Description], [IsSystemRole], [BusinessType], [IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate]) 
VALUES (N'AC4E0709-0C84-4CDD-98D4-0734E827853C', N'default', N'DEFAULT', N'b584331a-c989-41ff-b7a1-4c073e51a967', N'系统默认角色', N'系统默认角色', 1, 1, 0, N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2), N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2))

INSERT [cTest].[sys_Role] ([Id], [Name], [NormalizedName], [ConcurrencyStamp], [DisplayName], [Description], [IsSystemRole], [BusinessType], [IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate]) 
VALUES (N'B779D882-68ED-4298-B233-AA68065C447B', N'admin', N'ADMIN', N'b584331a-c989-41ff-b7a1-4c073e51a967', N'系统管理员', N'系统管理员', 1, 1, 0, N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2), N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2))

INSERT [cTest].[sys_Role] ([Id], [Name], [NormalizedName], [ConcurrencyStamp], [DisplayName], [Description], [IsSystemRole], [BusinessType], [IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate]) 
VALUES (N'2C8D8527-2C39-4321-8270-8549870718A9', N'hr', N'HR', N'b584331a-c989-41ff-b7a1-4c073e51a967', N'人力资源助理', N'人力资源助理', 1, 2, 0, N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2), N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2))
INSERT [cTest].[sys_Role] ([Id], [Name], [NormalizedName], [ConcurrencyStamp], [DisplayName], [Description], [IsSystemRole], [BusinessType], [IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate]) 
VALUES (N'79E08D9B-4301-4CE1-BF32-0285004D2B73', N'hrmanager', N'HRMANAGER', N'b584331a-c989-41ff-b7a1-4c073e51a967', N'人力资源经理', N'人力资源经理', 1, 2, 0, N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2), N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2))

INSERT [cTest].[sys_Role] ([Id], [Name], [NormalizedName], [ConcurrencyStamp], [DisplayName], [Description], [IsSystemRole], [BusinessType], [IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate]) 
VALUES (N'2DE1ABA7-E57D-47EC-9B6E-5E9904072400', N'sale', N'SALE', N'b584331a-c989-41ff-b7a1-4c073e51a967', N'采购助理', N'采购助理', 1, 8, 0, N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2), N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2))
INSERT [cTest].[sys_Role] ([Id], [Name], [NormalizedName], [ConcurrencyStamp], [DisplayName], [Description], [IsSystemRole], [BusinessType], [IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate]) 
VALUES (N'9A3A51A9-2ECD-40DC-990C-015A6AB17BF0', N'salemanager', N'SALEMANAGER', N'b584331a-c989-41ff-b7a1-4c073e51a967', N'采购经理', N'采购经理', 1, 8, 0, N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2), N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2))

INSERT [cTest].[sys_Role] ([Id], [Name], [NormalizedName], [ConcurrencyStamp], [DisplayName], [Description], [IsSystemRole], [BusinessType], [IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate]) 
VALUES (N'27B7C724-0A3F-438E-989E-8C7DF5D7989D', N'purchase', N'PURCHASE', N'b584331a-c989-41ff-b7a1-4c073e51a967', N'销售助理', N'销售助理', 1, 4, 0, N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2), N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2))
INSERT [cTest].[sys_Role] ([Id], [Name], [NormalizedName], [ConcurrencyStamp], [DisplayName], [Description], [IsSystemRole], [BusinessType], [IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate]) 
VALUES (N'0B6DE259-FBEA-401C-A112-4980AF659674', N'purchasemanager', N'PURCHASEMANAGER', N'b584331a-c989-41ff-b7a1-4c073e51a967', N'销售经理', N'销售经理', 1, 4, 0, N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2), N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2))

INSERT [cTest].[sys_Role] ([Id], [Name], [NormalizedName], [ConcurrencyStamp], [DisplayName], [Description], [IsSystemRole], [BusinessType], [IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate]) 
VALUES (N'2B01379C-5DD6-4B1D-AAD4-1151CDEFEDEA', N'warehouse', N'WAREHOUSE', N'b584331a-c989-41ff-b7a1-4c073e51a967', N'仓储助理', N'仓储助理', 1, 16, 0, N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2), N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2))
INSERT [cTest].[sys_Role] ([Id], [Name], [NormalizedName], [ConcurrencyStamp], [DisplayName], [Description], [IsSystemRole], [BusinessType], [IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate]) 
VALUES (N'771E4262-7498-46AA-A12F-986B98DB32C0', N'warehousemanager', N'WAREHOUSEMANAGER', N'b584331a-c989-41ff-b7a1-4c073e51a967', N'仓储经理', N'仓储经理', 1, 16, 0, N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2), N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2))

INSERT [cTest].[sys_Role] ([Id], [Name], [NormalizedName], [ConcurrencyStamp], [DisplayName], [Description], [IsSystemRole], [BusinessType], [IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate]) 
VALUES (N'4867C9B1-08A0-4B14-BB80-20CCB53C1D4D', N'manufacting', N'MANUFACTING', N'b584331a-c989-41ff-b7a1-4c073e51a967', N'生产助理', N'生产助理', 1, 32, 0, N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2), N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2))
INSERT [cTest].[sys_Role] ([Id], [Name], [NormalizedName], [ConcurrencyStamp], [DisplayName], [Description], [IsSystemRole], [BusinessType], [IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate]) 
VALUES (N'646E0519-CC98-4C18-9CF9-1117EE086BCB', N'manufactingmanager', N'MANUFACTINGMANAGER', N'b584331a-c989-41ff-b7a1-4c073e51a967', N'生产经理', N'生产经理', 1, 32, 0, N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2), N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2))

INSERT [cTest].[sys_Role] ([Id], [Name], [NormalizedName], [ConcurrencyStamp], [DisplayName], [Description], [IsSystemRole], [BusinessType], [IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate]) 
VALUES (N'98D8B16B-A191-49A5-ADFB-87BFA9B39EEF', N'qa', N'QA', N'b584331a-c989-41ff-b7a1-4c073e51a967', N'质检助理', N'质检助理', 1, 64, 0, N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2), N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2))
INSERT [cTest].[sys_Role] ([Id], [Name], [NormalizedName], [ConcurrencyStamp], [DisplayName], [Description], [IsSystemRole], [BusinessType], [IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate]) 
VALUES (N'2D309484-3D73-411A-9D16-704AB492DAA3', N'qamanager', N'QAMANAGER', N'b584331a-c989-41ff-b7a1-4c073e51a967', N'质检经理', N'质检经理', 1, 64, 0, N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2), N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2))

INSERT [cTest].[sys_Role] ([Id], [Name], [NormalizedName], [ConcurrencyStamp], [DisplayName], [Description], [IsSystemRole], [BusinessType], [IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate]) 
VALUES (N'9AC124B3-4D17-48BF-8713-8B9763DDB94E', N'marketing', N'MARKETING', N'b584331a-c989-41ff-b7a1-4c073e51a967', N'市场助理', N'市场助理', 1, 128, 0, N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2), N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2))
INSERT [cTest].[sys_Role] ([Id], [Name], [NormalizedName], [ConcurrencyStamp], [DisplayName], [Description], [IsSystemRole], [BusinessType], [IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate]) 
VALUES (N'B48B7AAA-CCDF-41CC-85AF-40FFA39BBFAD', N'marketingmanager', N'MARKETINGMANAGER', N'b584331a-c989-41ff-b7a1-4c073e51a967', N'市场经理', N'市场经理', 1, 128, 0, N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2), N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2))

INSERT [cTest].[sys_Role] ([Id], [Name], [NormalizedName], [ConcurrencyStamp], [DisplayName], [Description], [IsSystemRole], [BusinessType], [IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate]) 
VALUES (N'A5505492-5CAA-46F6-83A8-B8C75114380F', N'operator', N'OPERATOR', N'b584331a-c989-41ff-b7a1-4c073e51a967', N'运营助理', N'运营助理', 1, 256, 0, N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2), N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2))
INSERT [cTest].[sys_Role] ([Id], [Name], [NormalizedName], [ConcurrencyStamp], [DisplayName], [Description], [IsSystemRole], [BusinessType], [IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate]) 
VALUES (N'CAC720DE-1984-4DA6-B800-848B047B33D5', N'operatormanager', N'OPERATORMANAGER', N'b584331a-c989-41ff-b7a1-4c073e51a967', N'运营经理', N'运营经理', 1, 256, 0, N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2), N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2))

INSERT [cTest].[sys_Role] ([Id], [Name], [NormalizedName], [ConcurrencyStamp], [DisplayName], [Description], [IsSystemRole], [BusinessType], [IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate]) 
VALUES (N'9BD31CA9-A09E-4D38-AE0F-46765B11C7E9', N'accounting', N'ACCOUNTING', N'b584331a-c989-41ff-b7a1-4c073e51a967', N'财务助理', N'财务助理', 1, 256, 0, N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2), N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2))
INSERT [cTest].[sys_Role] ([Id], [Name], [NormalizedName], [ConcurrencyStamp], [DisplayName], [Description], [IsSystemRole], [BusinessType], [IsDeleted], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate]) 
VALUES (N'59E88BB5-C1F0-4899-89B7-A32A0714B447', N'accountingmanager', N'ACCOUNTINGMANAGER', N'b584331a-c989-41ff-b7a1-4c073e51a967', N'财务经理', N'财务经理', 1, 256, 0, N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2), N'admin', CAST(N'2019-01-01T00:00:00.0000000' AS DateTime2))
GO

INSERT [cTest].[sys_User] ([Id], [UserName], [NormalizedUserName], [Email], [NormalizedEmail], [EmailConfirmed], [PasswordHash], [SecurityStamp], [ConcurrencyStamp], [PhoneNumber], [PhoneNumberConfirmed], [TwoFactorEnabled], [LockoutEnd], [LockoutEnabled], [AccessFailedCount], [PositionLevel], [MemberId], [DisplayName], [CreateDate], [Recommended], [EmailConfirmedExpired], [EmailConfirmedDate], [ContactQQ], [Telephone], [IsDefaultMobile], [OpenId], [Status], [IsModifyPassword]) 
VALUES (N'ede9edf9-5909-42d0-8563-aaa5c04cd8c8', N'admin', N'ADMIN', N'tianchangjun@outlook.com', N'TIANCHANGJUN@OUTLOOK.COM', 0, N'AQAAAAEAACcQAAAAEAFw1YlS7M9JtsmpoSZA0SoNfN7aKN+iH4rGFq9uA/eD1B7wvlHkMG1M2WUhjdvcew==', N'XOQHPIFKKDEF4TKES3GQQDAM4AF564B4', N'821c849a-113c-493e-8bd6-25786b105dd0', N'', 0, 0, NULL, 0, 0, 0, N'USR00001', N'系统管理员', CAST(N'2018-12-01 00:00:00.0000000' AS DateTime2), NULL, NULL, NULL, NULL, NULL, 1, NULL, 2, 0)
INSERT [cTest].[sys_UsersInRoles] ([UserId], [RoleId]) 
VALUES (N'ede9edf9-5909-42d0-8563-aaa5c04cd8c8', N'B779D882-68ED-4298-B233-AA68065C447B')
INSERT [cTest].[sys_UsersInOrganizations] ([UserId], [OrganizationId]) 
VALUES (N'ede9edf9-5909-42d0-8563-aaa5c04cd8c8', 10)

GO
